Hi All,
We are on datastage v9.1 and trying to pull data from SQL Server. Connectivity has been established successfully via .odbc.ini and uvconfig.
Target SQL server is hosting five different databases on it out of which 4 has "dot" in their name while one has "underscore".
We are able to fetch data successfully from the database having name with underscore in it however no luck with database having dot in its name
So fully qualified table name looks like this
[string1.string2].dbo.[tablename]
In this [string1.string2] is database name, dbo is schema
What we have tried so far
1. Adding database name in .odbc.ini configuration itself which did not work - It fails connectivity with "can not open database"
2. Using query as select * from [string1.string2].dbo.[tablename] - This with many other combinations always yields result as "Invalid object Name"
Any pointers on this will be much appreciated. We are using ODBC connector stage at this moment
Thanks
SQL Server Data Pull with "dot" in database name
Moderators: chulett, rschirm, roy