Stack Overflow
Stack Overflow

Questions tagged [babelfish]

Babelfish for PostgreSQL by Amazon is a PostgreSQL server modification that enables PostgreSQL to speak the TDS protocol; see https://babelfishpg.org/

22 questions
2
votes
0 answers

Database Project over Babelfish

Has anyone had any luck publishing a VS Database Project over Babelfish? There is nothing on the net related to publishing .dacpac over BabelFish. I can connect and query via new query in SSMS, however, connection fails while attempting to publish a…
Ross Bush
  • 14,648
  • 2
  • 32
  • 55
1
vote
1 answer

REPLACE string with SUBSTRING function

Given input data: Col1 --------------------------------------- '-'::"varchar" COLLATE "default" '-1'::integer '0'::smallint …
MAK
  • 6,824
  • 25
  • 74
  • 131
1
vote
2 answers

How to use SQL Server's 'Select FOR JSON PATH' in AWS RDS Babelfish DB (Aurora PostgreSQL) using SSMS

Below existing T-SQL code which generates table data in JSON format just by using the keyword FOR JSON PATH, include_null_value. How to implement the same in Babelfish (Aurora PostgreSQL enabling Bablefish cluster) query by connecting to SSMS…
swapna s
  • 43
  • 5
1
vote
0 answers

Babelfish for Aurora PostgreSQL not returning generated row id

We recently converted our SQL Server database to AWS Aurora PostgreSQL(v.13.6). We're using Babelfish for Aurora PostgreSQL to connect to the database with Java 8 & JDBC & SQL Server driver. While testing, we discovered that Babelfish does NOT…
Peter Tarlos
  • 731
  • 10
  • 13
1
vote
1 answer

Create Aurora Cluster with Babelfish enables using Cloud Formation

Is there any way we can create an Aurora RDS Cluster Multi-AZ with Babelfish enabled using cloud formation. We can create it using [console or cli][1]. However, I want to create it using Cloudformation. I am not finding the options in the below…
Ali Mohsan
  • 326
  • 2
  • 15
1
vote
3 answers

Connecting to Aurora Postgres (Babelfish, 1433)

I'm attempting to connect to a new Aurora PostgreSQL instance with Babelfish enabled. NOTE: I am able to connect to the instance using the pg library through the normal port 5432 (the Postgres TDAS endpoint). However, for this test, I am attempting…
Nick
  • 466
  • 1
  • 6
  • 12
1
vote
1 answer

Using Postgresql Bablefish to connect Sybase app to Aurora Postgresql

I have a large Sybase ASE C/C++ app which I would like to migrate to Postgresql. The application is using the Sybase CT library (nothing complex: simple SQL, few bulk uploads, etc.). Application is built and run on Linux using SYBASE OCS-16. I'm…
dash-o
  • 13,723
  • 1
  • 10
  • 37
0
votes
3 answers

Unexpected XML element "_x0078_ml" in babelfish

create table #emp ( id int, name varchar(10) ); insert into #emp values(1,'A'),(2,'B'); create table #prd ( prid int, price int ); insert into #prd values(1,299),(2,295); Expected Output: I want to display result as shown below. …
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
0 answers

How to turn on Babelfish with AWS CDK

I have created an Aurora Serverless V2 Cluster with one reader and one writer Instance via CDK. Now I am trying to enable Babelfish for this cluster by adding a parameter group: const auroraParameterGroup = new rds.ParameterGroup(this,…
Vincent Elbracht
  • 1
  • 1
0
votes
3 answers

Update with from clause within user defined function

Writting function which should compatibile with Babelfish and SQL Server as well. The following function is having update statement with from and joins clause. CREATE FUNCTION fn_update_from_test() RETURNS @ListOWeekDays TABLE ( DyNumber INT, …
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
0 answers

Failed to create foreign table in babelfish_db under aurora PostgreSql environment

First, I am able to create foreign table in original postgres table under aurora PostgreSql environment. However, we actaully want to create a foreign table under babelfish_db table under aurora PostgreSql which helps use to intreact with our other…
EasonEason
  • 1
0
votes
1 answer

Performance tuning select query with OR condition in JOIN

I have large SELECT query to find out the product related details. Some part of the query is taking too much time due to OR condition in the JOIN. Sample code: Existing query: --Time Taken: 00:00:04 --Records : 179384 SELECT * FROM ProductMaster…
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
2 answers

Babelfish : UPDATE query with JOIN

I have the following sample data: create table employee (id int,emp_name varchar(50),project_name varchar(50)); insert into employee(id,emp_name) values(1,'Smith'); insert into employee(id,emp_name) values(2,'Jill'); insert into…
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
1 answer

Optimize query to get distinct records

I have the following query to get product sold count. Present Query: Which gives duplicate records. --(322212 rows affected) --00:00:08 Time Taken SELECT pc.qty_typecode , pc.prdcost, AS prdcost , pc.d1cost, AS d1cost , …
MAK
  • 6,824
  • 25
  • 74
  • 131
0
votes
1 answer

AWS Babelfish with Postgres is throwing sporadic error

we are using AWS Babelfish with Postgres enabled DB, ideally it's a Postgres DB. There are frequent errors related to could not open relation. The same SP executes fine sometimes and same one fails with error sporadically if not more frequently. I…
Manjunath
  • 323
  • 1
  • 3
  • 15
1
2